{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import os\n",
    "import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "   序号 申请\\n单位 工作\\n地点 设备\\n类型          设备名称           主要工作内容       停役日期  \\\n",
       "0   1     省检    天一变     母线  220kV副母II段母线      副母II段侧旧设备拆除 2021-03-01   \n",
       "1   2     省检    天一变     线路       天下4483线             间隔陪停 2021-03-01   \n",
       "2   3   输电中心     线路     线路       天下4483线  1）线路C级安；2）避雷器安装 2021-03-01   \n",
       "3   4     省检    天一变     母线          2号母联        设备拆除及土建施工 2021-03-01   \n",
       "4   5     省检    天一变     母线  220kV正母II段母线      正母II段侧旧设备拆除 2021-03-04   \n",
       "\n",
       "        复役日期  停电\\n天数     电压 施工\\n单位 检修\\n性质                          项目负责人  \\\n",
       "0 2021-03-02       2  220kV     省检     基建  省检：俞文慧/677234\\n运检部：程国开/651946   \n",
       "1 2021-03-02       2  220kV     省检     基建                            NaN   \n",
       "2 2021-03-02       2  220kV   输电中心     检修                            NaN   \n",
       "3 2021-05-25      86  220kV     省检     基建                            NaN   \n",
       "4 2021-03-06       3  220kV     省检     基建                            NaN   \n",
       "\n",
       "                      备注及说明  \n",
       "0  快速开关加装\\n（#2母联开关）\\n五级电网风险  \n",
       "1                       NaN  \n",
       "2                       NaN  \n",
       "3                       NaN  \n",
       "4                       NaN  "
      ],
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>序号</th>\n      <th>申请\\n单位</th>\n      <th>工作\\n地点</th>\n      <th>设备\\n类型</th>\n      <th>设备名称</th>\n      <th>主要工作内容</th>\n      <th>停役日期</th>\n      <th>复役日期</th>\n      <th>停电\\n天数</th>\n      <th>电压</th>\n      <th>施工\\n单位</th>\n      <th>检修\\n性质</th>\n      <th>项目负责人</th>\n      <th>备注及说明</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>1</td>\n      <td>省检</td>\n      <td>天一变</td>\n      <td>母线</td>\n      <td>220kV副母II段母线</td>\n      <td>副母II段侧旧设备拆除</td>\n      <td>2021-03-01</td>\n      <td>2021-03-02</td>\n      <td>2</td>\n      <td>220kV</td>\n      <td>省检</td>\n      <td>基建</td>\n      <td>省检：俞文慧/677234\\n运检部：程国开/651946</td>\n      <td>快速开关加装\\n（#2母联开关）\\n五级电网风险</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>2</td>\n      <td>省检</td>\n      <td>天一变</td>\n      <td>线路</td>\n      <td>天下4483线</td>\n      <td>间隔陪停</td>\n      <td>2021-03-01</td>\n      <td>2021-03-02</td>\n      <td>2</td>\n      <td>220kV</td>\n      <td>省检</td>\n      <td>基建</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>3</td>\n      <td>输电中心</td>\n      <td>线路</td>\n      <td>线路</td>\n      <td>天下4483线</td>\n      <td>1）线路C级安；2）避雷器安装</td>\n      <td>2021-03-01</td>\n      <td>2021-03-02</td>\n      <td>2</td>\n      <td>220kV</td>\n      <td>输电中心</td>\n      <td>检修</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>4</td>\n      <td>省检</td>\n      <td>天一变</td>\n      <td>母线</td>\n      <td>2号母联</td>\n      <td>设备拆除及土建施工</td>\n      <td>2021-03-01</td>\n      <td>2021-05-25</td>\n      <td>86</td>\n      <td>220kV</td>\n      <td>省检</td>\n      <td>基建</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>5</td>\n      <td>省检</td>\n      <td>天一变</td>\n      <td>母线</td>\n      <td>220kV正母II段母线</td>\n      <td>正母II段侧旧设备拆除</td>\n      <td>2021-03-04</td>\n      <td>2021-03-06</td>\n      <td>3</td>\n      <td>220kV</td>\n      <td>省检</td>\n      <td>基建</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "metadata": {},
     "execution_count": 2
    }
   ],
   "source": [
    "dt = pd.read_excel(r'F:\\python\\file_tools\\生产计划生成ics日历文件\\data\\新计划表（202103-04）.xlsx',sheet_name = '220kV')\n",
    "dt.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "2021-03-01 00:00:00\n"
     ]
    }
   ],
   "source": [
    "print(dt.iloc[1:2].iloc[0,6])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "2021-03-02 00:00:00\nTZID=Asia/Shanghai:20210301T080000\nTZID=Asia/Shanghai:20210302T173000\n2021-03-01 08:00:00\n"
     ]
    }
   ],
   "source": [
    "print(dt.iloc[1,7])\n",
    "DTSTART=datetime.datetime(year=dt.iloc[1:2].iloc[0,6].year,month=dt.iloc[1:2].iloc[0,6].month,day=dt.iloc[1:2].iloc[0,6].day,hour=8,minute=0,second=0)\n",
    "DTEND=datetime.datetime(year=dt.iloc[1:2].iloc[0,7].year,month=dt.iloc[1:2].iloc[0,7].month,day=dt.iloc[1:2].iloc[0,7].day,hour=17,minute=30,second=0)\n",
    "#time_format = \"TZID=Asia/Shanghai:{date.year}{date.month:0>2d}{date.day:0>2d}T{date.hour:0>2d}{date.minute:0>2d}00\"\n",
    "time_format = \"TZID=Asia/Shanghai:{date.year}{date.month:0>2d}{date.day:0>2d}T{date.hour:0>2d}{date.minute:0>2d}00\"\n",
    "dt_start = time_format.format(date=DTSTART)\n",
    "dt_end = time_format.format(date=DTEND)\n",
    "print(dt_start)\n",
    "print(dt_end)\n",
    "print(DTSTART)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp1 = 'BEGIN:VCALENDAR\\nVERSION:2.0\\nCALSCALE:GREGORIAN\\nMETHOD:PUBLISH\\nX-WR-CALNAME:my_schedule\\nX-WR-TIMEZONE:null\\n'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "BEGIN:VCALENDAR\nVERSION:2.0\nCALSCALE:GREGORIAN\nMETHOD:PUBLISH\nX-WR-CALNAME:my_schedule\nX-WR-TIMEZONE:null\n\n"
     ]
    }
   ],
   "source": [
    "print(temp1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "tags": [
     "outputPrepend"
    ]
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "MARY:溪凤变-#2主变-工厂化大修、保护改造\nDTSTART;TZID=Asia/Shanghai:20211109T080000\nDTEND;TZID=Asia/Shanghai:20211123T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:溪凤变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:溪凤变-#2主变-配合跨线更换\nDTSTART;TZID=Asia/Shanghai:20211118T080000\nDTEND;TZID=Asia/Shanghai:20211118T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:溪凤变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:溪凤变-#1主变-配合跨线更换\nDTSTART;TZID=Asia/Shanghai:20211118T080000\nDTEND;TZID=Asia/Shanghai:20211118T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:溪凤变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:甬钢变-#1机组-D修\nDTSTART;TZID=Asia/Shanghai:20211108T080000\nDTEND;TZID=Asia/Shanghai:20211113T173000\nSEQUENCE:0\nDESCRIPTION:甬钢变-大修\nLOCATION:甬钢变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:建中变-#1主变-主变保护反措、首检、主变针对性试验\nDTSTART;TZID=Asia/Shanghai:20211119T080000\nDTEND;TZID=Asia/Shanghai:20211121T173000\nSEQUENCE:0\nDESCRIPTION:运维部：王纶/661658-首检\n五级电网风险\nLOCATION:建中变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:建中变-#2主变-主变保护反措、首检、主变针对性试验\nDTSTART;TZID=Asia/Shanghai:20211122T080000\nDTEND;TZID=Asia/Shanghai:20211124T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:建中变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:长石变-#1主变-主变保护、合并单元、智能终端反措、C检\nDTSTART;TZID=Asia/Shanghai:20211125T080000\nDTEND;TZID=Asia/Shanghai:20211127T173000\nSEQUENCE:0\nDESCRIPTION:运检部：谢凌东/678936\n励文伟/667231-反措\n五级电网风险\nLOCATION:长石变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:长石变-#2主变-主变保护、合并单元、智能终端反措、C检\nDTSTART;TZID=Asia/Shanghai:20211128T080000\nDTEND;TZID=Asia/Shanghai:20211130T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:长石变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:惠明变-#1主变-副母闸刀大修、间隔维护消缺\nDTSTART;TZID=Asia/Shanghai:20211108T080000\nDTEND;TZID=Asia/Shanghai:20211110T173000\nSEQUENCE:0\nDESCRIPTION:运检部：谢凌东/678936-综合检修\n六级电网风险\nLOCATION:惠明变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:惠明变-#2主变-副母闸刀大修、间隔维护消缺\nDTSTART;TZID=Asia/Shanghai:20211111T080000\nDTEND;TZID=Asia/Shanghai:20211113T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:惠明变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:淞浦变-#1主变-正母闸刀更换；C检；保护改造\nDTSTART;TZID=Asia/Shanghai:20211129T080000\nDTEND;TZID=Asia/Shanghai:20211213T173000\nSEQUENCE:0\nDESCRIPTION:运检部：谢凌东/678936-淞浦变220kV正母线综合检修\nLOCATION:淞浦变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nEND:VCALENDARBEGIN:VEVENT\nSUMMARY:天一变-220kV副母II段母线-副母II段侧旧设备拆除\nDTSTART;TZID=Asia/Shanghai:20211001T080000\nDTEND;TZID=Asia/Shanghai:20211002T173000\nSEQUENCE:0\nDESCRIPTION:省检：俞文慧/677234\n运检部：程国开/651946-快速开关加装\n（#2母联开关）\n五级电网风险\nLOCATION:天一变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:天一变-天下4483线-间隔陪停\nDTSTART;TZID=Asia/Shanghai:20211001T080000\nDTEND;TZID=Asia/Shanghai:20211002T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:天一变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:线路-天下4483线-1）线路C级安；2）避雷器安装\nDTSTART;TZID=Asia/Shanghai:20211001T080000\nDTEND;TZID=Asia/Shanghai:20211002T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:线路\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:天一变-2号母联-设备拆除及土建施工\nDTSTART;TZID=Asia/Shanghai:20211001T080000\nDTEND;TZID=Asia/Shanghai:20211225T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:天一变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:天一变-220kV正母II段母线-正母II段侧旧设备拆除\nDTSTART;TZID=Asia/Shanghai:20211004T080000\nDTEND;TZID=Asia/Shanghai:20211006T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:天一变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:天一变-天展4482线-间隔陪停\nDTSTART;TZID=Asia/Shanghai:20211001T080000\nDTEND;TZID=Asia/Shanghai:20211006T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:天一变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:线路-天展4482线-线路C检\nDTSTART;TZID=Asia/Shanghai:20211001T080000\nDTEND;TZID=Asia/Shanghai:20211006T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:线路\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:威远变-220kV正母Ⅱ段母线-主变扩建、间隔C检等工作\nDTSTART;TZID=Asia/Shanghai:20211023T080000\nDTEND;TZID=Asia/Shanghai:20211024T173000\nSEQUENCE:0\nDESCRIPTION:省检：俞文慧/677234-威远主变扩建\n五级电网风险\nLOCATION:威远变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:威远变-2号主变-配合新主变低压设备吊装陪停等工作\nDTSTART;TZID=Asia/Shanghai:20211026T080000\nDTEND;TZID=Asia/Shanghai:20211209T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:威远变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:威远变-北远5404线-配合新主变传动等工作\nDTSTART;TZID=Asia/Shanghai:20211027T080000\nDTEND;TZID=Asia/Shanghai:20211029T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:威远变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:威远变-500kVⅠ母线-配合新主变传动、耐压试验等工作\nDTSTART;TZID=Asia/Shanghai:20211031T080000\nDTEND;TZID=Asia/Shanghai:20211103T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:威远变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:威远变-220kV副母Ⅱ段母线-主变扩建、间隔C检等工作\nDTSTART;TZID=Asia/Shanghai:20201110T080000\nDTEND;TZID=Asia/Shanghai:20201111T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:威远变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:钱湖变-钱晓5P32线- 2号主变500kV侧软母线安装等工作\nDTSTART;TZID=Asia/Shanghai:20211001T080000\nDTEND;TZID=Asia/Shanghai:20211008T173000\nSEQUENCE:0\nDESCRIPTION:省检：俞文慧/677234-钱湖主变扩建\n五级电网风险\nLOCATION:钱湖变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:钱湖变-500kVII段母线-配合新主变传动、耐压试验等工作\nDTSTART;TZID=Asia/Shanghai:20211001T080000\nDTEND;TZID=Asia/Shanghai:20211008T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:钱湖变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:钱湖变-500kVⅠ段母线-配合新主变传动、耐压试验等工作\nDTSTART;TZID=Asia/Shanghai:20211013T080000\nDTEND;TZID=Asia/Shanghai:20211018T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:钱湖变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:钱湖变-220kV副母Ⅰ段母线-配合主变扩建、间隔C检等工作\nDTSTART;TZID=Asia/Shanghai:20211010T080000\nDTEND;TZID=Asia/Shanghai:20211011T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:钱湖变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:钱湖变-220kV正母Ⅰ段母线-配合主变扩建、间隔C检等工作\nDTSTART;TZID=Asia/Shanghai:20201029T080000\nDTEND;TZID=Asia/Shanghai:20201030T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:钱湖变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:线路-华溪2P35线-动态增容\nDTSTART;TZID=Asia/Shanghai:20211006T080000\nDTEND;TZID=Asia/Shanghai:20211008T173000\nSEQUENCE:0\nDESCRIPTION:运检部：程国开/651947-动态增容\nLOCATION:线路\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:线路-华凤2P36线-动态增容\nDTSTART;TZID=Asia/Shanghai:20211009T080000\nDTEND;TZID=Asia/Shanghai:20211011T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:线路\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:线路-湖福44F1线-配合镇新、镇乐改接入新新乐线路跨越陪停。\nDTSTART;TZID=Asia/Shanghai:20201020T080000\nDTEND;TZID=Asia/Shanghai:20201030T173000\nSEQUENCE:0\nDESCRIPTION:基建部：顾立东/662892-新新乐工程\n五级电网风险\nLOCATION:线路\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:线路-湖新44F3线-线路改接至新新乐，保护联调\nDTSTART;TZID=Asia/Shanghai:20201004T080000\nDTEND;TZID=Asia/Shanghai:20201013T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:线路\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:线路-湖新44F3线-线路改接至新新乐，保护联调\nDTSTART;TZID=Asia/Shanghai:20201004T080000\nDTEND;TZID=Asia/Shanghai:20201013T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:线路\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:溪凤变-#2主变-工厂化大修、配合110kV全停#1、#2、#3主变及110母联跨线更换陪停\nDTSTART;TZID=Asia/Shanghai:20211019T080000\nDTEND;TZID=Asia/Shanghai:20211105T173000\nSEQUENCE:0\nDESCRIPTION:运维部：王纶/661658-工厂化大修\nLOCATION:溪凤变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:广济变-#3主变-配合110kV母联、分段扩建、首检\nDTSTART;TZID=Asia/Shanghai:20211021T080000\nDTEND;TZID=Asia/Shanghai:20211025T173000\nSEQUENCE:0\nDESCRIPTION:运维部：王纶/661658-110kV分段扩建\nLOCATION:广济变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:邬隘变-#4主变-配合宝幢GIS间隔就位及拼接\nDTSTART;TZID=Asia/Shanghai:20211014T080000\nDTEND;TZID=Asia/Shanghai:20211029T173000\nSEQUENCE:0\nDESCRIPTION:基建部：张中华657203-宝幢变工程\nLOCATION:邬隘变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:雁苍变-220kV副母线-配合各间隔副母闸刀检修\nDTSTART;TZID=Asia/Shanghai:20211009T080000\nDTEND;TZID=Asia/Shanghai:20211015T173000\nSEQUENCE:0\nDESCRIPTION:运维部：谢凌东678936\n省检：俞文慧/677234-雁苍变综合检修、测控改造\n五级电网风险\nLOCATION:雁苍变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:雁苍变-220kV母联开关-副母闸刀检修；C检；测控改造\nDTSTART;TZID=Asia/Shanghai:20211009T080000\nDTEND;TZID=Asia/Shanghai:20211015T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:雁苍变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:雁苍变-#2主变-副母闸刀检修；C检；测控改造、主变消防改造。\nDTSTART;TZID=Asia/Shanghai:20211004T080000\nDTEND;TZID=Asia/Shanghai:20211012T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:雁苍变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:雁苍变-宁雁4P55线-副母闸刀检修；C检；测控改造\nDTSTART;TZID=Asia/Shanghai:20211007T080000\nDTEND;TZID=Asia/Shanghai:20211012T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:雁苍变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:宁海变-宁雁4P55线-副母闸刀检修；C检；测控改造\nDTSTART;TZID=Asia/Shanghai:20211007T080000\nDTEND;TZID=Asia/Shanghai:20211012T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:宁海变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:线路-宁雁4P55线-1）线路C检；2）防风偏绝缘子加装；3）三跨段后备线夹安装及X光检测；4）分布式故障定位装置加装；5）避雷器加装\nDTSTART;TZID=Asia/Shanghai:20211007T080000\nDTEND;TZID=Asia/Shanghai:20211012T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:线路\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:雁苍变-#1主变-副母闸刀检修；C检；测控改造；保护改造、主变消防改造。\nDTSTART;TZID=Asia/Shanghai:20211013T080000\nDTEND;TZID=Asia/Shanghai:20211027T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:雁苍变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:雁苍变-宁苍4P56线-副母闸刀检修；C检；测控改造\nDTSTART;TZID=Asia/Shanghai:20211013T080000\nDTEND;TZID=Asia/Shanghai:20211018T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:雁苍变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:宁海变-宁苍4P56线-副母闸刀检修；C检；测控改造\nDTSTART;TZID=Asia/Shanghai:20211013T080000\nDTEND;TZID=Asia/Shanghai:20211018T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:宁海变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:线路-宁苍4P56线-1）线路C检；2）防风偏绝缘子加装；3）三跨段后备线夹安装及X光检测；4）分布式故障定位装置加装；5）避雷器加装\nDTSTART;TZID=Asia/Shanghai:20211013T080000\nDTEND;TZID=Asia/Shanghai:20211018T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:线路\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:雁苍变-#3主变-首检、主变消防改造\nDTSTART;TZID=Asia/Shanghai:20211028T080000\nDTEND;TZID=Asia/Shanghai:20211030T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:雁苍变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:通济变-220kV正母压变-监控改造\nDTSTART;TZID=Asia/Shanghai:20211002T080000\nDTEND;TZID=Asia/Shanghai:20211007T173000\nSEQUENCE:0\nDESCRIPTION:林维修651526-测控改造、消缺\n五级电网风险\nLOCATION:通济变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:通济变-220kV正母线-220kV正母压变闸刀消缺\nDTSTART;TZID=Asia/Shanghai:20211002T080000\nDTEND;TZID=Asia/Shanghai:20211002T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:通济变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:同山变-宁同4P51线-防拒动反措\nDTSTART;TZID=Asia/Shanghai:20211026T080000\nDTEND;TZID=Asia/Shanghai:20211026T173000\nSEQUENCE:0\nDESCRIPTION:谢凌东678936-反措\nLOCATION:同山变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:牛牵变-青铁2R06线-年检\nDTSTART;TZID=Asia/Shanghai:20211018T080000\nDTEND;TZID=Asia/Shanghai:20211018T173000\nSEQUENCE:0\nDESCRIPTION:上铁调：俞益飞-五级电网风险\nLOCATION:牛牵变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:线路-青铁2R06线-消缺\nDTSTART;TZID=Asia/Shanghai:20211018T080000\nDTEND;TZID=Asia/Shanghai:20211018T173000\nSEQUENCE:0\nDESCRIPTION:运检部：程国开/651947-nan\nLOCATION:线路\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:天一变-2号母联-设备拆除及土建施工\nDTSTART;TZID=Asia/Shanghai:20211001T080000\nDTEND;TZID=Asia/Shanghai:20211225T173000\nSEQUENCE:0\nDESCRIPTION:省检：俞文慧/677234-上月延续\nLOCATION:天一变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:威远变-2号主变-配合新主变低压设备吊装陪停等工作\nDTSTART;TZID=Asia/Shanghai:20211026T080000\nDTEND;TZID=Asia/Shanghai:20211209T173000\nSEQUENCE:0\nDESCRIPTION:省检：俞文慧/677234-上月延续\nLOCATION:威远变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:威远变-500kVⅠ母线-配合新主变传动、耐压试验等工作\nDTSTART;TZID=Asia/Shanghai:20211031T080000\nDTEND;TZID=Asia/Shanghai:20211103T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:威远变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:威远变-220kV副母Ⅱ段母线-主变扩建、间隔C检等工作\nDTSTART;TZID=Asia/Shanghai:20201110T080000\nDTEND;TZID=Asia/Shanghai:20201111T173000\nSEQUENCE:0\nDESCRIPTION:nan-主变扩建\n五级电网风险\nLOCATION:威远变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:句章变-1号主变-中性点小电抗加装\nDTSTART;TZID=Asia/Shanghai:20211116T080000\nDTEND;TZID=Asia/Shanghai:20211122T173000\nSEQUENCE:0\nDESCRIPTION:省检：俞文慧/677234-小电抗加装\nLOCATION:句章变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:句章变-2号主变-中性点小电抗加装\nDTSTART;TZID=Asia/Shanghai:20211124T080000\nDTEND;TZID=Asia/Shanghai:20211130T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:句章变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:句章变-3号主变-中性点小电抗加装\nDTSTART;TZID=Asia/Shanghai:20211201T080000\nDTEND;TZID=Asia/Shanghai:20211208T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:句章变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:钱湖变-3号主变-中性点小电抗加装\nDTSTART;TZID=Asia/Shanghai:20211107T080000\nDTEND;TZID=Asia/Shanghai:20211111T173000\nSEQUENCE:0\nDESCRIPTION:省检：俞文慧/677234-小电抗加装\nLOCATION:钱湖变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:明州变-舜明5846线-深瑞反措、发热消缺\nDTSTART;TZID=Asia/Shanghai:20211102T080000\nDTEND;TZID=Asia/Shanghai:20211119T173000\nSEQUENCE:0\nDESCRIPTION:省检：俞文慧/677234-消缺、抗冰改造\nLOCATION:明州变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:线路-舜明5846线-1）线路C检；2）97#～114#抗冰改造；3）老旧复合绝缘子更换等。\nDTSTART;TZID=Asia/Shanghai:20211102T080000\nDTEND;TZID=Asia/Shanghai:20211119T173000\nSEQUENCE:0\nDESCRIPTION:运检部：程国开/651947-nan\nLOCATION:线路\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:慈溪变-220kV母联开关-C检\nDTSTART;TZID=Asia/Shanghai:20211120T080000\nDTEND;TZID=Asia/Shanghai:20211121T173000\nSEQUENCE:0\nDESCRIPTION:运检部：谢凌东/678936-C检\nLOCATION:慈溪变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:慈溪变-220kV旁路开关-C检\nDTSTART;TZID=Asia/Shanghai:20211122T080000\nDTEND;TZID=Asia/Shanghai:20211123T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:慈溪变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:鲍家变-鲍澄23H5线-首检\nDTSTART;TZID=Asia/Shanghai:20211124T080000\nDTEND;TZID=Asia/Shanghai:20211126T173000\nSEQUENCE:0\nDESCRIPTION:运检部：谢凌东/678936-首检\nLOCATION:鲍家变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:澄浪变-鲍澄23H5线-首检\nDTSTART;TZID=Asia/Shanghai:20211124T080000\nDTEND;TZID=Asia/Shanghai:20211126T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:澄浪变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:线路-鲍澄23H5线-电缆段消缺\nDTSTART;TZID=Asia/Shanghai:20211124T080000\nDTEND;TZID=Asia/Shanghai:20211126T173000\nSEQUENCE:0\nDESCRIPTION:运检部：熊吉/656466-消缺\nLOCATION:线路\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:鲍家变-220kV母联开关-LTD时间继电器反措；C检\nDTSTART;TZID=Asia/Shanghai:20211127T080000\nDTEND;TZID=Asia/Shanghai:20211129T173000\nSEQUENCE:0\nDESCRIPTION:运检部：谢凌东/678936-反措\n五级电网风险\nLOCATION:鲍家变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:鲍家变-#2主变-LTD时间继电器反措；C检\nDTSTART;TZID=Asia/Shanghai:20211127T080000\nDTEND;TZID=Asia/Shanghai:20211129T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:鲍家变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:屯山变-220kV母联开关-负荷转供加装\nDTSTART;TZID=Asia/Shanghai:20211121T080000\nDTEND;TZID=Asia/Shanghai:20211121T173000\nSEQUENCE:0\nDESCRIPTION:运检部：励文伟/667231-负荷转供\n五级电网风险\nLOCATION:屯山变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:屯山变-姆屯4P75线-负荷转供加装\nDTSTART;TZID=Asia/Shanghai:20211122T080000\nDTEND;TZID=Asia/Shanghai:20211122T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:屯山变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:屯山变-姆山4P76线-负荷转供加装\nDTSTART;TZID=Asia/Shanghai:20211123T080000\nDTEND;TZID=Asia/Shanghai:20211123T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:屯山变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:屯山变-屯济2318线-负荷转供加装\nDTSTART;TZID=Asia/Shanghai:20211124T080000\nDTEND;TZID=Asia/Shanghai:20211124T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:屯山变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:屯山变-屯上2319线-负荷转供加装\nDTSTART;TZID=Asia/Shanghai:20211125T080000\nDTEND;TZID=Asia/Shanghai:20211124T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:屯山变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:沿海变-沿跟2P30线-引线拉紧消缺\nDTSTART;TZID=Asia/Shanghai:20211115T080000\nDTEND;TZID=Asia/Shanghai:20211115T173000\nSEQUENCE:0\nDESCRIPTION:运检部：谢凌东/678936-消缺\nLOCATION:沿海变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:厚墩变-#1主变-配合中芯间隔扩建母线打压陪停\nDTSTART;TZID=Asia/Shanghai:20211114T080000\nDTEND;TZID=Asia/Shanghai:20211121T173000\nSEQUENCE:0\nDESCRIPTION:基建部：杨韩庆/656282-间隔扩建\n六级电网风险\nLOCATION:厚墩变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:厚墩变-厚双1928线-C检\nDTSTART;TZID=Asia/Shanghai:20211114T080000\nDTEND;TZID=Asia/Shanghai:20211121T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:厚墩变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:厚墩变-#2主变-主变保护反措\nDTSTART;TZID=Asia/Shanghai:20211113T080000\nDTEND;TZID=Asia/Shanghai:20211113T173000\nSEQUENCE:0\nDESCRIPTION:运维部：王纶/661658-间隔扩建\n六级电网风险\nLOCATION:厚墩变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:溪凤变-#3主变-工厂化大修、保护改造\nDTSTART;TZID=Asia/Shanghai:20211025T080000\nDTEND;TZID=Asia/Shanghai:20211108T173000\nSEQUENCE:0\nDESCRIPTION:运维部：王纶/661658-工厂化大修\n五级电网风险\nLOCATION:溪凤变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:溪凤变-#2主变-工厂化大修、保护改造\nDTSTART;TZID=Asia/Shanghai:20211109T080000\nDTEND;TZID=Asia/Shanghai:20211123T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:溪凤变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:溪凤变-#2主变-配合跨线更换\nDTSTART;TZID=Asia/Shanghai:20211118T080000\nDTEND;TZID=Asia/Shanghai:20211118T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:溪凤变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:溪凤变-#1主变-配合跨线更换\nDTSTART;TZID=Asia/Shanghai:20211118T080000\nDTEND;TZID=Asia/Shanghai:20211118T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:溪凤变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:甬钢变-#1机组-D修\nDTSTART;TZID=Asia/Shanghai:20211108T080000\nDTEND;TZID=Asia/Shanghai:20211113T173000\nSEQUENCE:0\nDESCRIPTION:甬钢变-大修\nLOCATION:甬钢变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:建中变-#1主变-主变保护反措、首检、主变针对性试验\nDTSTART;TZID=Asia/Shanghai:20211119T080000\nDTEND;TZID=Asia/Shanghai:20211121T173000\nSEQUENCE:0\nDESCRIPTION:运维部：王纶/661658-首检\n五级电网风险\nLOCATION:建中变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:建中变-#2主变-主变保护反措、首检、主变针对性试验\nDTSTART;TZID=Asia/Shanghai:20211122T080000\nDTEND;TZID=Asia/Shanghai:20211124T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:建中变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:长石变-#1主变-主变保护、合并单元、智能终端反措、C检\nDTSTART;TZID=Asia/Shanghai:20211125T080000\nDTEND;TZID=Asia/Shanghai:20211127T173000\nSEQUENCE:0\nDESCRIPTION:运检部：谢凌东/678936\n励文伟/667231-反措\n五级电网风险\nLOCATION:长石变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:长石变-#2主变-主变保护、合并单元、智能终端反措、C检\nDTSTART;TZID=Asia/Shanghai:20211128T080000\nDTEND;TZID=Asia/Shanghai:20211130T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:长石变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:惠明变-#1主变-副母闸刀大修、间隔维护消缺\nDTSTART;TZID=Asia/Shanghai:20211108T080000\nDTEND;TZID=Asia/Shanghai:20211110T173000\nSEQUENCE:0\nDESCRIPTION:运检部：谢凌东/678936-综合检修\n六级电网风险\nLOCATION:惠明变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:惠明变-#2主变-副母闸刀大修、间隔维护消缺\nDTSTART;TZID=Asia/Shanghai:20211111T080000\nDTEND;TZID=Asia/Shanghai:20211113T173000\nSEQUENCE:0\nDESCRIPTION:nan-nan\nLOCATION:惠明变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nBEGIN:VEVENT\nSUMMARY:淞浦变-#1主变-正母闸刀更换；C检；保护改造\nDTSTART;TZID=Asia/Shanghai:20211129T080000\nDTEND;TZID=Asia/Shanghai:20211213T173000\nSEQUENCE:0\nDESCRIPTION:运检部：谢凌东/678936-淞浦变220kV正母线综合检修\nLOCATION:淞浦变\nSTATUS:CONFIRMED\nTRANSP:OPAQUE\nEND:VEVENT\nEND:VCALENDAR\n"
     ]
    }
   ],
   "source": [
    "# print(dt.shape[0])\n",
    "def add_event(dt):\n",
    "    des = ''\n",
    "    DTSTART = datetime.datetime(year=dt.iloc[0,6].year,month=dt.iloc[0,6].month+7,day=dt.iloc[0,6].day,hour=8,minute=0,second=0)\n",
    "    DTEND = datetime.datetime(year=dt.iloc[0,7].year,month=dt.iloc[0,7].month+7,day=dt.iloc[0,7].day,hour=17,minute=30,second=0)\n",
    "    time_format = \"TZID=Asia/Shanghai:{date.year}{date.month:0>2d}{date.day:0>2d}T{date.hour:0>2d}{date.minute:0>2d}00\"\n",
    "    dt_start = time_format.format(date=DTSTART)\n",
    "    dt_end = time_format.format(date=DTEND)\n",
    "    des = des + 'BEGIN:VEVENT\\n'\n",
    "    des = des + 'SUMMARY:'+ dt.iloc[0,2] + '-' + dt.iloc[0,4] + '-' + dt.iloc[0,5] + '\\n'\n",
    "    des = des + 'DTSTART;'+ dt_start +'\\n'\n",
    "    des = des + 'DTEND;'+ dt_end + '\\n'\n",
    "    des = des + 'SEQUENCE:0'+'\\n'\n",
    "    # des = des + 'DESCRIPTION:\\n'      \n",
    "    des = des + 'DESCRIPTION:' +  str(dt.iloc[0,12]) + '-' + str(dt.iloc[0,13]) + '\\n'\n",
    "    des = des + 'LOCATION:' + dt.iloc[0,2]+'\\n'\n",
    "    des = des +'STATUS:CONFIRMED\\nTRANSP:OPAQUE\\nEND:VEVENT\\n'\n",
    "    return des\n",
    "for i in range(0,dt.shape[0]):\n",
    "    temp1 = temp1 + add_event(dt.iloc[i:i+1])\n",
    "temp1 = temp1 + 'END:VCALENDAR'\n",
    "jihua = open('220kV-计划.ics','w')\n",
    "jihua.write(temp1)\n",
    "jihua.close\n",
    "print(temp1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "name": "python3",
   "display_name": "Python 3.9.2 64-bit",
   "metadata": {
    "interpreter": {
     "hash": "0d008810b9c8467bcb3ca39aa2180e5b81b3a9acb136aab30d47954377cc5120"
    }
   }
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.2-final"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}